<?php

/**
 * This is the model class for table "{{post}}".
 *
 * The followings are the available columns in table '{{post}}':
 * @property integer $id
 * @property string $title
 * @property string $content
 * @property string $tags
 * @property integer $status
 * @property integer $create_time
 * @property integer $update_time
 * @property integer $author_id
 *
 * The followings are the available model relations:
 * @property Comment[] $comments
 * @property User $author
 */
class Post extends CActiveRecord {
	const STATUS_NAME = "PostStatus";
	const STATUS_DRAFT = 1;
	const STATUS_PUBLISHED = 2;
	const STATUS_ARCHIVED = 3;
	public function getUrl() {
		return Yii::app ()->createAbsoluteUrl ( 'post/view', array (
				'id' => $this->id 
		) );
	}
	
	/**
	 * 添加评论.
	 * 
	 * @param Comment $comment        	
	 */
	public function addComment($comment) {
		if (Yii::app ()->params ['commentNeedApproval'])
			$comment->status = Comment::STATUS_PENDING;
		else
			$comment->status = Comment::STATUS_APPROVED;
		$comment->post_id = $this->id;
		$comment->author = Yii::app ()->user->isGuest ? 'guest' : Yii::app ()->user->id;
		return $comment->save ();
	}
	
	/**
	 * 根据ID返回
	 *
	 * @param unknown $id        	
	 * @return Ambigous <CActiveRecord, mixed, NULL, unknown, multitype:unknown Ambigous <unknown, NULL> , multitype:, multitype:unknown Ambigous <CActiveRecord, NULL> , multitype:unknown >
	 */
	public static function getById($id) {
		$status = implode ( ",", array (
				self::STATUS_PUBLISHED, 
				self::STATUS_ARCHIVED 
		) );
		$contition = array (
				"condition" => "status IN (" . $status . ")" 
		);
		return self::model ()->findByPk ( $id, $contition );
	}
	
	/**
	 * (non-PHPdoc)
	 *
	 * @see CActiveRecord::beforeSave()
	 */
	protected function beforeSave() {
		if (parent::beforeSave ()) {
			if ($this->isNewRecord) {
				$this->create_time = $this->update_time = TIMESTAMP;
				$this->author_id = Yii::app ()->user->id;
			} else {
				$this->update_time = TIMESTAMP;
			}
			return true;
		}
		return false;
	}
	public function normalizeTags($attribute, $params) {
		$this->tags = Tag::array2string ( array_unique ( Tag::string2array ( $this->tags ) ) );
	}
	
	/**
	 * Returns the static model of the specified AR class.
	 *
	 * @param string $className
	 *        	active record class name.
	 * @return Post the static model class
	 */
	public static function model($className = __CLASS__) {
		return parent::model ( $className );
	}
	
	/**
	 *
	 * @return string the associated database table name
	 */
	public function tableName() {
		return '{{post}}';
	}
	
	/**
	 *
	 * @return array validation rules for model attributes.
	 */
	public function rules() {
		// NOTE: you should only define rules for those attributes that
		// will receive user inputs.
		return array (
				
				array (
						'title, content, status, author_id', 
						'required' 
				), 
				
				array (
						'title', 
						'length', 
						'max' => 128 
				), 
				
				array (
						'status, create_time, update_time, author_id', 
						'numerical', 
						'integerOnly' => true 
				), 
				
				array (
						'status', 
						'in', 
						'range' => array (
								self::STATUS_DRAFT, 
								self::STATUS_PUBLISHED, 
								self::STATUS_ARCHIVED 
						) 
				), 
				
				array (
						'title, tags', 
						'safe' 
				), 
				
				array (
						'tags', 
						'normalizeTags' 
				), 
				
				array (
						'tags', 
						'match', 
						'pattern' => '/^[\w\s,]+$/', 
						'message' => '标签只能是中英文字符' 
				), 
				
				// The following rule is used by search().
				// Please remove those attributes that should not be searched.
				// title, content, tags, status, create_time, update_time, author_id
				array (
						'id, ', 
						'safe', 
						'on' => 'search' 
				) 
		);
	}
	
	/**
	 *
	 * @return array relational rules.
	 */
	public function relations() {
		// NOTE: you may need to adjust the relation name and the related
		// class name for the relations automatically generated below.
		return array (
				'comments' => array (
						self::HAS_MANY, 
						'Comment', 
						'post_id', 
						'condition' => 'status=' . Comment::STATUS_APPROVED, 
						'order' => 'create_time DESC' 
				),  // comments
				
				'author' => array (
						self::BELONGS_TO, 
						'User', 
						'author_id' 
				),  // author
				
				'commentCount' => array (
						self::STAT, 
						'Comment', 
						'post_id', 
						'condition' => 'status=' . Comment::STATUS_APPROVED 
				) 
		); // commentCount
	}
	
	/**
	 *
	 * @return array customized attribute labels (name=>label)
	 */
	public function attributeLabels() {
		return array (
				'id' => Yii::t ( 'lng_post', 'post_ID' ), 
				
				'title' => Yii::t ( 'lng_post', 'post_Title' ), 
				
				'content' => Yii::t ( 'lng_post', 'post_Content' ), 
				
				'tags' => Yii::t ( 'lng_post', 'Tags' ), 
				
				'status' => Yii::t ( 'lng_post', 'Status' ), 
				
				'create_time' => Yii::t ( 'lng_post', 'Create Time' ), 
				
				'update_time' => Yii::t ( 'lng_post', 'Update Time' ), 
				
				'author_id' => Yii::t ( 'lng_post', 'Author' ) 
		);
	}
	
	/**
	 * Retrieves a list of models based on the current search/filter conditions.
	 *
	 * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
	 */
	public function search() {
		// Warning: Please modify the following code to remove attributes that
		// should not be searched.
		$criteria = new CDbCriteria ();
		
		$criteria->compare ( 'id', $this->id );
		$criteria->compare ( 'title', $this->title, true );
		$criteria->compare ( 'content', $this->content, true );
		$criteria->compare ( 'tags', $this->tags, true );
		$criteria->compare ( 'status', $this->status );
		$criteria->compare ( 'create_time', $this->create_time );
		$criteria->compare ( 'update_time', $this->update_time );
		$criteria->compare ( 'author_id', $this->author_id );
		
		return new CActiveDataProvider ( $this, array (
				'criteria' => $criteria 
		) );
	}
}